//
//  GPDBConst.m
//  GuaPi
//
//  Created by 23 on 2017/7/9.
//  Copyright © 2017年 Joanlove. All rights reserved.
//

#import "GPDBConst.h"


/**数据库名称前缀*/
NSString * const kProfileDBPrefix = @"GP_DB_Profile";

/**数据库表-用户资料表名*/
NSString * const DB_CHAT_TABLE_PROFILE = @"DB_CHAT_TABLE_PROFILE";

/**创建用户资料数据表sql*/
NSString * const SQL_CREATE_Profile =
                                        @"CREATE TABLE IF NOT EXISTS %@ (\
                                        id          integer        PRIMARY KEY  autoincrement,\
                                        uid         TEXT           ,\
                                        hid         TEXT           unique,\
                                        name        TEXT,\
                                        age         integer,\
                                        phone       TEXT,\
                                        sex         integer,\
                                        avatarURL   TEXT,\
                                        realName    TEXT,\
                                        isBlock     bool,\
                                        remarks     TEXT)";


